from sqlalchemy import Column, create_engine, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()


class AppInfoTable(Base):
    __tablename__ = 'app_info_table'
    src_app_name = Column(String(20))
    search_app_name = Column(String(20))
    search_pkg_name = Column(String(20), primary_key=True)
    app_classification = Column(String(20))
    user_score = Column(String(20))
    downloads = Column(String(20))
    comment_number = Column(String(20))
    version = Column(String(20))
    update_time = Column(String(20))
    developer = Column(String(20))
    app_info = Column(String(20))
    add_time = Column(String(20))
